Migración datos Burcamp

Origen:
burcampprod
burcampproduser
2dplE651ZO23LgBx

Destino:
burcamprestored
burcamprestoreduser
2dplE651ZO23LgBx

Ids
6317
6318


SELECT *
FROM `wp_amv_orders`
WHERE `transaccionId` IN (6318, 6317);

Gitlab
ssh ubuntu@34.203.171.118
nMv5!Un?whCF6V8yGiQN

Pruebas Burcamp
ssh root@167.172.237.195
L5j/sz~R<$h]Q;ER7o

Produccion Burcamp
ssh root@159.203.144.236
6$zXbD06Sx.6KHatm7H*d

Copias de seguridad

mysqldump -v -h localhost -u burcamprestoreduser -p2dplE651ZO23LgBx burcamprestored > burcamprestored-dest-23-05-2026.sql

mysqldump -v -h localhost -u burcampproduser -p2dplE651ZO23LgBx burcampprod > burcampprod-origin--23-05-2026.sql

----------- local mac ------

wget http://qa.burcamp.co/burcampprod-origin--23-05-2026.sql

wget http://qa.burcamp.co/burcamprestored-dest-23-05-2026.sql


mysql -u root -p
sucer2007

CREATE DATABASE burcamp_ori;
CREATE USER 'burcamp_ori'@'localhost' IDENTIFIED BY '2dplE651ZO23LgBx';
GRANT select,update,delete,insert,create,drop,index,alter,lock tables, execute, create temporary tables, execute, trigger, create view, show view, event ON burcamp_ori.* TO burcamp_ori@'localhost';
FLUSH PRIVILEGES;
exit;


mysql -v -h localhost -u burcamp_ori -p burcamp_ori < burcampprod-origin--23-05-2026.sql
2dplE651ZO23LgBx


mysql -u root -p
sucer2007

CREATE DATABASE burcamp_dest;
CREATE USER 'burcamp_dest'@'localhost' IDENTIFIED BY '2dplE651ZO23LgBx';
GRANT select,update,delete,insert,create,drop,index,alter,lock tables, execute, create temporary tables, execute, trigger, create view, show view, event ON burcamp_dest.* TO burcamp_dest@'localhost';
FLUSH PRIVILEGES;
exit;

mysql -v -h localhost -u burcamp_dest -p burcamp_dest < burcamprestored-dest-23-05-2026.sql
2dplE651ZO23LgBx

-------------------- resultados de la prueba local ---------------------
burcampqa
burcampqauser
2dplE651ZO23LgBx